C:/Projekte/RAIS/FillCustomQueryTableCL/Parameter.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Xml;
using RAIS.DataAccessLayer;
namespace FillCustomQueryTableCL
{
    public class Parameter
    {
        #region Constants
        
        public static readonly string START_DATE_NAME = "StartDate";
        public static readonly string END_DATE_NAME = "EndDate";
        public static readonly string USER_ID_NAME = "UserID";

        public static readonly string TABLE_ID_FIELD = "TableID";
        public static readonly string ORDER_FIELD = "Order";
        public static readonly string PARAM_NAME_FIELD = "ParamName";
        public static readonly string QUERY_NAME_FIELD = "QueryName";
        public static readonly string RELATION_QUERY_NAME = "RelationQueryName";
        public static readonly string VISIBLE_NAME_FIELD = "VisibleName";

        public static Dictionary<string, int> ParameterTypes = new Dictionary<string, int>();

        private static readonly string GetParameterTypes =
                                "SELECT " +
                                "    [PK Query Parameter Type ID], " +
                                "    [Query Parameter Type Name] " +
                                "FROM [Query Parameter Type] ";
        #endregion


        public static void InitParameter(string connectionString)
        {
                        if (ParameterTypes.Count == 0)
                        {
                                using (SqlConnection sqlConnection = new SqlConnection(connectionString))
                                {
                                        sqlConnection.Open();
                                        using (SqlCommand sqlCommand = new SqlCommand("", sqlConnection))
                                        {
                                                sqlCommand.CommandText = GetParameterTypes;
                                                using (SqlDataReader reader = sqlCommand.ExecuteReader())
                                                {
                                                        while (reader.Read())
                                                                ParameterTypes.Add((string)reader["Query Parameter Type Name"], (int)reader["PK Query Parameter Type ID"]);
                                                        ParameterTypes.Add("DateRange", 0xFFFFFFF);
                                                }
                                        }
                                }
                        }
        }


        #region Fields
        protected string name;
        protected string visibleName;
        protected int type;
        protected int tableID;
        protected string relatedQueryName;
        protected int order;
        protected string queryName;
        #endregion

        #region Properties
        public string TypeName
        {
            set { type = ParameterTypes[value]; }
        }

        public string QueryName
        {
            get { return queryName; }
            set { queryName = value; }
        }
        public string Name
        {
            get { return name; }
            set { name = value; }
        }
        public string VisibleName
        {
            get { return visibleName; }
            set { visibleName = value; }
        }
        public int Type
        {
            get { return type; }
            set { type = value; }
        }
        public int TableID
        {
            get { return tableID; }
            set { tableID = value; }
        }
        public string RelatedQueryName
        {
            get { return relatedQueryName; }
            set { relatedQueryName = value; }
        }
        public int Order
        {
            get { return order; }
            set { order = value; }
        }
        #endregion

        #region Constructors        
        public Parameter(string queryName, string name, string visibleName, int type, int tableID, string relatedQueryName, int order)
        {
            this.queryName = queryName;
            this.name = name;
            this.visibleName = visibleName;
            this.type = type;
            this.tableID = tableID;
            this.relatedQueryName = relatedQueryName;
            this.order = order;
        }

        public Parameter(string queryName, string name, string visibleName, string type, int tableID, string relatedQueryName, int order):
                this(queryName, name, visibleName, ParameterTypes[type], tableID, relatedQueryName, order)
        {}

        #endregion

        #region Public methods
        public Parameter(SqlDataReader reader)
        {
            VisibleName = (string)reader[VISIBLE_NAME_FIELD];
            if ((string)reader[Parameter.RELATION_QUERY_NAME] == "")
                relatedQueryName = null;
            else
                relatedQueryName = (string)reader[Parameter.RELATION_QUERY_NAME];

            if (reader[TABLE_ID_FIELD] == DBNull.Value)
                tableID = -1;
            else
                tableID = (int)reader[TABLE_ID_FIELD];

            order = (int)reader[ORDER_FIELD];
            name = (string)reader[PARAM_NAME_FIELD];

            if (visibleName == "User")
            {
                type = ParameterTypes["UserID"];
                name = USER_ID_NAME;
            }
            else if (visibleName == "DatesRange")
                type = ParameterTypes["DateRange"];
            else if (relatedQueryName == null)
                type = ParameterTypes["LookupFromTable"];
            else
                type = ParameterTypes["LookupFromQuery"];
        }
        public virtual Parameter Clone()
        {
            return new Parameter(queryName, name, visibleName, type, tableID, relatedQueryName, order);
        }
        public void WriteToXML(XmlWriter xw)
        {
            xw.WriteStartElement("Parameter");
            xw.WriteAttributeString("QueryName", queryName);
            xw.WriteAttributeString("ParameterName", name);
            xw.WriteAttributeString("ParameterType", type.ToString());
            if (tableID != -1)
                xw.WriteAttributeString("TableID", tableID.ToString());
            if (!string.IsNullOrEmpty(relatedQueryName))
                xw.WriteAttributeString("RelatedQueryName", relatedQueryName);
            xw.WriteAttributeString("Order", order.ToString());
            xw.WriteAttributeString("VisibleName", visibleName);
            xw.WriteEndElement();
        }
        #endregion
    }
}